package com.yuexin.services;

import java.util.Vector;

import com.yuexin.dao.SqlManager;
import com.yuexin.handler.StorageGoodsHandler;
import com.yuexin.model.StorageGoods;

public class StorageGoodsServices implements StorageGoodsHandler {
    SqlManager manage = null;

    public StorageGoodsServices() {
        super();
        manage = SqlManager.createInstance();
        manage.connectDB();
    }

    public Vector<StorageGoods> getAllStorageGoods() {
        Vector<StorageGoods> result = new Vector<StorageGoods>();
//    	try
//		{
//			String sql="select * from tb_goods ";
//			ResultSet rs=manage.executeQuery(sql, null, Constants.CALL_TYPE);
//			while(rs.next())
//			{
//				Customer person=new Customer(rs.getString("id"),rs.getString("customername"),rs.getString("zip"),
//					     rs.getString("address"),rs.getString("telephone"),rs.getString("connectionPerson"),
//					     rs.getString("phone"),rs.getString("bank"),rs.getString("account"),
//					     rs.getString("email"),rs.getString("fax"));
//				result.add(person);
//			}
//			manage.closeDB();
//		}
//		catch (Exception e)
//		{
//			ErrorManager.printError("CustomerDAO.getAllCustomer", e);
//		}
        return result;
    }
}
